Labels:text | screenshot | font | number | black and white | document OCR: Procedure A named PL/SQL block that performs one or more actions and is called as an executable PL/SQL statement. You can pass information into and out of a procedure through its parameter list. Function A named PL/SQL block that returns a single value and is used just like a PL/SQL expression. You can pass information into a function through its parameter list. Anonymous An unnamed PL/SQL block that performs one or more actions. Block An anonymous block gives the developer control over scope of identifiers and exception handling. Package A named collection of procedures, functions, types, and variables. A package is not really a module (it's more of a meta-module), but it is so tightly related to modules that I mention it here. Figure 1: Different ways to modularize your code.
(1999).iso/orinf/jun96/feuef101.gif){kind=small}
(1999).iso/orinf/jun96/feuef102.gif){kind=link}